- English only?
- CreationDate ist read-only
- Mapping Media Type --> bringt Martin mit
- Wer soll als byr_ah_projectLead gesetzt werden? Brand Comm representative für beide Felder?
- Soll muss der MAM-Uploader irgendwo gespeichert werden?
- "Bayer Animal Health GmbH" immer als License Holder OK?
- "comment" mit in description?
- MAM-Status "ARCHIVED" --> eDAM.Archived?
- Was ist mit Status != ACCEPTED or ARCHIVED?
- Regelung Cutover: Kein Upload mehr ab KW42 (16.10.)

License:
- Wenn License Holder nicht gesetzt, trotzdem BAH GmbH? (bspw. 00070763) --> mandatory
- release.forInternet/forIntranet --> License comments
- GPC owner/e-mail?

GPC:
- Beispiel für ausgefüllte GPC-Daten/Wird GPC-Block verwendet?
- was ist mit regionalLicenseComment/personalLicenseComment?
- Ist "Date of Issue" Release Date? Ist gpc.expirationDate = LMR Expiration Date?
- GPC No. = LMR ID?


- Timeline
  - Fertigstellung Migrations-Programm
  - Download/Upload Metadaten
  - Download/Upload Dateien


CREATE TABLE Record (
  ID INTEGER GENERATED BY DEFAULT AS IDENTITY(START WITH 0) NOT NULL PRIMARY KEY,
  Location VARCHAR NOT NULL,
  Entry VARCHAR NOT NULL)
AS SELECT
  null,
  Location,
  Entry
FROM CSVREAD('C:/Temp/Migration AH/entry.log', null, 'charset=UTF-8 fieldSeparator=|~|');

SELECT * FROM Record;

CALL CSVWRITE ('C:/Temp/Migration AH/entries.csv', 'SELECT * FROM Record', 'charset=UTF-8');



DROP ALL OBJECTS


CREATE TABLE Entry (
  ID INTEGER GENERATED BY DEFAULT AS IDENTITY(START WITH 0) NOT NULL PRIMARY KEY,
  EntryId INTEGER NOT NULL,
  EntryIdString VARCHAR NOT NULL,
  MediaType INTEGER NOT NULL,
  Filesize BIGINT NOT NULL,
  Json VARCHAR NOT NULL)
AS SELECT
  null,
  EntryId,
  EntryIdString,
  MediaType,
  Filesize,
  Json
FROM CSVREAD('C:/Temp/Migration AH/migration.log', 'EntryId|~|EntryIdString|~|MediaType|~|Filesize|~|Json', 'charset=UTF-8 fieldSeparator=|~|');

SELECT * FROM Entry;

CALL CSVWRITE ('C:/Temp/Migration AH/migration.csv', 'SELECT * FROM Entry', 'charset=UTF-8');



